<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DateWiseAttdDataset" targetNamespace="http://tempuri.org/DateWiseAttdDataset.xsd" xmlns:mstns="http://tempuri.org/DateWiseAttdDataset.xsd" xmlns="http://tempuri.org/DateWiseAttdDataset.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="ConnectionString (Settings)" PropertyReference="ApplicationSettings.eBirdAttend.Properties.Settings.GlobalReference.Default.ConnectionString" Provider="System.Data.OleDb">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DateWiseAttndViewTableAdapter" GeneratorDataComponentClassName="DateWiseAttndViewTableAdapter" Name="DateWiseAttndView" UserDataComponentName="DateWiseAttndViewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="eOffice_new.dbo.DateWiseAttndView" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT    dtEmpID as "Employee Id", dtDate as Date, EmpFirstName as "First Name", EmpLastName as "Last Name",  dtHours "Hours", dtMinutes as "Minutes", dtFirstInTime "First Time In", dtLastOutTime "Last Time Out", dtOverTimeMin "Over Time", dtLatenessMin as "Lateness Minutes", 
                      dtTotWorkedMin as "Total Worked Minutes"
FROM         DateWiseAttndView</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Employee Id" DataSetColumn="Employee Id" />
              <Mapping SourceColumn="Date" DataSetColumn="Date" />
              <Mapping SourceColumn="First Name" DataSetColumn="First Name" />
              <Mapping SourceColumn="Last Name" DataSetColumn="Last Name" />
              <Mapping SourceColumn="Hours" DataSetColumn="Hours" />
              <Mapping SourceColumn="Minutes" DataSetColumn="Minutes" />
              <Mapping SourceColumn="First Time In" DataSetColumn="First Time In" />
              <Mapping SourceColumn="Last Time Out" DataSetColumn="Last Time Out" />
              <Mapping SourceColumn="Over Time" DataSetColumn="Over Time" />
              <Mapping SourceColumn="Lateness Minutes" DataSetColumn="Lateness Minutes" />
              <Mapping SourceColumn="Total Worked Minutes" DataSetColumn="Total Worked Minutes" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DateWiseAttdDataset" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DateWiseAttdDataset" msprop:Generator_DataSetName="DateWiseAttdDataset">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DateWiseAttndView" msprop:Generator_UserTableName="DateWiseAttndView" msprop:Generator_RowDeletedName="DateWiseAttndViewRowDeleted" msprop:Generator_RowChangedName="DateWiseAttndViewRowChanged" msprop:Generator_RowClassName="DateWiseAttndViewRow" msprop:Generator_RowChangingName="DateWiseAttndViewRowChanging" msprop:Generator_RowEvArgName="DateWiseAttndViewRowChangeEvent" msprop:Generator_RowEvHandlerName="DateWiseAttndViewRowChangeEventHandler" msprop:Generator_TableClassName="DateWiseAttndViewDataTable" msprop:Generator_TableVarName="tableDateWiseAttndView" msprop:Generator_RowDeletingName="DateWiseAttndViewRowDeleting" msprop:Generator_TablePropName="DateWiseAttndView">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Employee_x0020_Id" msprop:Generator_UserColumnName="Employee Id" msprop:Generator_ColumnVarNameInTable="columnEmployee_Id" msprop:Generator_ColumnPropNameInRow="Employee_Id" msprop:Generator_ColumnPropNameInTable="Employee_IdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnPropNameInTable="DateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="First_x0020_Name" msprop:Generator_UserColumnName="First Name" msprop:Generator_ColumnVarNameInTable="columnFirst_Name" msprop:Generator_ColumnPropNameInRow="First_Name" msprop:Generator_ColumnPropNameInTable="First_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Last_x0020_Name" msprop:Generator_UserColumnName="Last Name" msprop:Generator_ColumnVarNameInTable="columnLast_Name" msprop:Generator_ColumnPropNameInRow="Last_Name" msprop:Generator_ColumnPropNameInTable="Last_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Hours" msprop:Generator_UserColumnName="Hours" msprop:Generator_ColumnVarNameInTable="columnHours" msprop:Generator_ColumnPropNameInRow="Hours" msprop:Generator_ColumnPropNameInTable="HoursColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Minutes" msprop:Generator_UserColumnName="Minutes" msprop:Generator_ColumnVarNameInTable="columnMinutes" msprop:Generator_ColumnPropNameInRow="Minutes" msprop:Generator_ColumnPropNameInTable="MinutesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="First_x0020_Time_x0020_In" msprop:Generator_UserColumnName="First Time In" msprop:Generator_ColumnVarNameInTable="columnFirst_Time_In" msprop:Generator_ColumnPropNameInRow="First_Time_In" msprop:Generator_ColumnPropNameInTable="First_Time_InColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Last_x0020_Time_x0020_Out" msprop:Generator_UserColumnName="Last Time Out" msprop:Generator_ColumnVarNameInTable="columnLast_Time_Out" msprop:Generator_ColumnPropNameInRow="Last_Time_Out" msprop:Generator_ColumnPropNameInTable="Last_Time_OutColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Over_x0020_Time" msprop:Generator_UserColumnName="Over Time" msprop:Generator_ColumnVarNameInTable="columnOver_Time" msprop:Generator_ColumnPropNameInRow="Over_Time" msprop:Generator_ColumnPropNameInTable="Over_TimeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Lateness_x0020_Minutes" msprop:Generator_UserColumnName="Lateness Minutes" msprop:Generator_ColumnVarNameInTable="columnLateness_Minutes" msprop:Generator_ColumnPropNameInRow="Lateness_Minutes" msprop:Generator_ColumnPropNameInTable="Lateness_MinutesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Total_x0020_Worked_x0020_Minutes" msprop:Generator_UserColumnName="Total Worked Minutes" msprop:Generator_ColumnVarNameInTable="columnTotal_Worked_Minutes" msprop:Generator_ColumnPropNameInRow="Total_Worked_Minutes" msprop:Generator_ColumnPropNameInTable="Total_Worked_MinutesColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>